UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZdpQqNJIPK0/vvyOwqnivOJRAYGUJfXOMNCvbqhOCtE='
WHERE
key_id = '461b4128e77c94a170286b525e812939e3b5e172557c27456e4fda5b90063820'
AND (
token = 'ZdpQqNJIPK0/vvyOwqnivOJRAYGUJfXOMNCvbqhOCtE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)