UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6f0Jrf6pYYbAaXqmEDfc0EbnoCgqycIR5wGBj4ja9M0='
WHERE
key_id = '18b11453c50d81c6624eb4a2b61a304b66e5661d671941d5c0a81a65533c4a71'
AND (
token = '6f0Jrf6pYYbAaXqmEDfc0EbnoCgqycIR5wGBj4ja9M0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)