UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HGSbcEJ8sHrtfETG5HjA/ujzTk0hN2igEhjYE8Qhx7M='
WHERE
key_id = '23a0460361154b0c29016f0fd3e43d1d1c9b3634046744e2af18823b448df016'
AND (
token = 'HGSbcEJ8sHrtfETG5HjA/ujzTk0hN2igEhjYE8Qhx7M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)