UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7FTqez7RQF2pPEcwRaw9op8ER3Z4ze826wkAkrKh2Z0='
WHERE
key_id = 'a64da4086e72dc7419c33e83e4fa6d9a54f0eac3b1f2a5c66db9daa7b5484cb0'
AND (
token = '7FTqez7RQF2pPEcwRaw9op8ER3Z4ze826wkAkrKh2Z0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)