UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SR05KMsULb1fg8sN26EbF0m4jvDdPrDdE0eop4eTpU0='
WHERE
key_id = '6c0ee7dee2162cd737086a4b19e6385a87e75912279e8c69dc9302eff98ce060'
AND (
token = 'SR05KMsULb1fg8sN26EbF0m4jvDdPrDdE0eop4eTpU0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)