UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1KiO9Rlwi5Sf/LkVKnYfxtHAS2ptUsa2AkXkcUvZbnc='
WHERE
key_id = 'bd62872d518eddef93d749a4d8ab586129d678b75465e3bfed911eb21f59233b'
AND (
token = '1KiO9Rlwi5Sf/LkVKnYfxtHAS2ptUsa2AkXkcUvZbnc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)