UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NPMk4uFQVpfQXiSRPWYW81KwJAVuVf6dSk5wDds1Fnk='
WHERE
key_id = 'e27ce1c94243f71b4c7d1f6ea6837d0a9ccb15dd3366d5ea5026b1f10051d93d'
AND (
token = 'NPMk4uFQVpfQXiSRPWYW81KwJAVuVf6dSk5wDds1Fnk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)