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