UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/pc6Y6qKRFYI0F66QNDoIxokIjGuMIHro1Rmh1ZLIHU='
WHERE
key_id = '4275984ed22e9cb1967f1002f9864d7c3cb6c0d4ba54f95e99ad1c55731509f6'
AND (
token = '/pc6Y6qKRFYI0F66QNDoIxokIjGuMIHro1Rmh1ZLIHU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)