UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9h97is8SwfZwGnOi3gcsHikI+jtLSC5Pf4ofV6notbw='
WHERE
key_id = '5007e91743148dde787a7d953613d8eb7b23ccc9abb8484624aae8e2e8bd75e9'
AND (
token = '9h97is8SwfZwGnOi3gcsHikI+jtLSC5Pf4ofV6notbw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)