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