UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Bv7jOqGkb8VBE451qWNkQS+dzj7/rhzd3wfFNpr51RI='
WHERE
key_id = '16b3cfcbd191cbf2ee004948d7526393ae01a1a5d5d3bdd4e1bf012b10bbe42c'
AND (
token = 'Bv7jOqGkb8VBE451qWNkQS+dzj7/rhzd3wfFNpr51RI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)