UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QFzQIZ2U8xmQWB+QATk6OzeTFUFzNfuDBgJf+/r0+94='
WHERE
key_id = 'c928050c7783a9f7995caa6c4bf00d84f2a4b9920ae4e86b2e0af6a9413bd7df'
AND (
token = 'QFzQIZ2U8xmQWB+QATk6OzeTFUFzNfuDBgJf+/r0+94='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)