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