UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7hg8RA+tHbS0b97s5NyQPkcdEFktiDmSVfUv+iYu5Gg='
WHERE
key_id = '7a3b8950d915fb4f89577b5fa45f06980b21fb92529c52927f8ffe321ee49cc9'
AND (
token = '7hg8RA+tHbS0b97s5NyQPkcdEFktiDmSVfUv+iYu5Gg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)