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