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