UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QiN85eYuGikY84TgrQVl7Y+eKpC/Nl9/bwoq2h6yHg0='
WHERE
key_id = 'd99c9907574b485b3a34f2a942d57f5ebdcb01817c938b71a08c6c616e112760'
AND (
token = 'QiN85eYuGikY84TgrQVl7Y+eKpC/Nl9/bwoq2h6yHg0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)