UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dkLsI1VrydkhZhZ0WbM0Bw/BzOgG3VYyPZdP7w+mudg='
WHERE
key_id = 'c6c27fd701071e9c086979034196b138010f62800a36a0ea0c9025d91d5289dd'
AND (
token = 'dkLsI1VrydkhZhZ0WbM0Bw/BzOgG3VYyPZdP7w+mudg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)