UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'epc2oHisLxXVQ2HAi3KZoSB2FJDCzRq3s2jEQsUZyY4='
WHERE
key_id = 'bc5505bd1ef00490e6632f7641d240936012c18ea84c8d849b0f3e5a301184e2'
AND (
token = 'epc2oHisLxXVQ2HAi3KZoSB2FJDCzRq3s2jEQsUZyY4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)