UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D17KhWau/iiLtpAVWZmqxIcPAt5dmsZ7gmrp2H1069Y='
WHERE
key_id = 'c388c41af17c22373da1a7bb649e43c9225e0efbf8cbc9b9da77b0ea75df38df'
AND (
token = 'D17KhWau/iiLtpAVWZmqxIcPAt5dmsZ7gmrp2H1069Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)