UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZtMgCeorJ7B3iKaTQymYERHdUPq6dAYOKFH+aL4juSE='
WHERE
key_id = 'e4e3936248c15929f77bf5eccf757bcf0a576de9e39d54c8a1acb88e832b4470'
AND (
token = 'ZtMgCeorJ7B3iKaTQymYERHdUPq6dAYOKFH+aL4juSE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)