UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tG5toaQeVrW6itANjrgI8pUaKYSX1FeleMQbfMR2rRE='
WHERE
key_id = '06c118692c0fc46479167ab2f13569355304a1bfb04245adc474fe2665d2a6dd'
AND (
token = 'tG5toaQeVrW6itANjrgI8pUaKYSX1FeleMQbfMR2rRE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)