UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8XxCMdc94g9j3YZnDA7vK3HsrURwar/Vqj8ydOLLThA='
WHERE
key_id = '42867cfdc141fae0d1b645d96298cd064e087668143b065edd8065d0eb21162e'
AND (
token = '8XxCMdc94g9j3YZnDA7vK3HsrURwar/Vqj8ydOLLThA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)