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