UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6x2WGoc3A27n8NlqTs9CLtoX1L4E9kc7k2I5qCGiP5E='
WHERE
key_id = '3e83389263c569922ec6b516a67a93dfb7cef904ef86afa018427771c331f5a8'
AND (
token = '6x2WGoc3A27n8NlqTs9CLtoX1L4E9kc7k2I5qCGiP5E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)