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