UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pFSMxBbjanUMa5tJ5LId/iT/X22SFy5AKXHlnlD6HEo='
WHERE
key_id = '16178e1f16510f06f7aae2faf60eb02c7ca191948a5d23e9914e8b6f959f3918'
AND (
token = 'pFSMxBbjanUMa5tJ5LId/iT/X22SFy5AKXHlnlD6HEo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)